home *** CD-ROM | disk | FTP | other *** search
/ Agent Central Host Computer / Agent - Central Host Computer.iso / _SETUP.1 / vdayadjust.sql < prev    next >
Text File  |  2000-05-12  |  417b  |  12 lines
  1. /*
  2. This view sums all the day adjustments. The outer join is to ensure that there is a record for the vcbcount view to process.
  3. */
  4. create or replace view vdayadjust as
  5. select sum(total_adjust) day_adjust, 
  6.     acctdaytotals.acctday_total_seq_num 
  7. from adjustment , 
  8.     acctdaytotals
  9. where adjustment.acctday_total_seq_num (+) = acctdaytotals.acctday_total_seq_num
  10. group by acctdaytotals.acctday_total_seq_num;
  11.  
  12.